package com.saishi.dao;

import com.saishi.entity.Classes;
import com.saishi.entity.Question;
import com.saishi.entity.User;
import com.saishi.entity.classuser;
import com.saishi.entity.uclass;

import java.sql.Date;
import java.sql.SQLException;
import java.util.List;

public interface UserDao {
     //登录
    List<User> Login(String user,String pass,String tel,String emile) throws Exception;

    //注册
    List add(int uid,String uusername,String tel,String pass) throws SQLException;
    //通过用户名查询某个用户
    List<User> seuserlist(String usern) throws Exception;

    //修改用户信息
    int updayhxx(String nic,String sex,int nage,String zhiye,String address,String email,String username) throws SQLException;

    //修改用户密码
    int upuserpass(String newpass,String username) throws SQLException;
    //查询所有
    List<User> allQuery() throws SQLException;
    //添加数据
    int adduid(User user) throws  SQLException;

    public int del(int uid) throws  SQLException;

    public int update(User user) throws SQLException;

    User myup(int uid) throws SQLException;
    //改班
    uclass findclass(int uid)throws SQLException;
    //查询班级
    List chefind()throws SQLException;
    //查询班级id
    List<Classes> cfind(String cname)throws  SQLException;
    int upbj(int uid,String cname) throws  SQLException;
    //批量添加班级学生
    int cadd(String cname, String sort, String sta,int cid)throws SQLException;
    int ucadd(classuser uc)throws  SQLException;
    //查询学生id
    List<User> uacc(String acc)throws  SQLException;
    ///查询所有班
    List<Classes> call()throws SQLException;
}
